The name of the product.

In most cases copied from the external catalog.

The Product ID of the product.

Most times this ID is not interesting.

The Product Class of the product.

Field is useful for search and filter to products.

Constructions with parent products are possible. The parent ID might be displayed here.

Working with product families or parent ID's is not usually in combination with external Product Catalogs.

Product number from the manufacturer.

Important number to identify the Product independent from the manufacturer.

Link to a website of the manufacturer with detailed information about the product here.

The manufacturer of the product.

If the manufacturer didn't exist yet, the name will be added to the entity Manufacturer.

It might be that a product is already announced but not for sale yet.

It also might be that a product gets retired and cannot be ordered after the mentioned Valid To date. 

Description of the product.

Validity start date of the product.

Date of the last change of the product.

GTIN of the predecessor.

Product ID of the Predecessor.

GTIN of the successor.

Product ID of the successor.

Information about the type and the actual version of the product.

The used Unit Group from CE.

Mostly by default Pieces. Other unit groups might be Time or Distance but these are not applicable for External Catalogs. The unit group time can be applicable for renting equipment.

Default Unit copied from the external catalog.

Mostly Pieces or Meter.

Price List from the settings.

Decimals supported from the product.

Most times the decimals given from the provider of the catalog are OK.

Not applicable for external catalogs.

Name of the Product Catalog provider the product is copied from.

Name of the Online Product Catalog.

It might be that several Catalog Providers or Product Catalogs are used in the same environment. Here you can see the source of the product. If there is only one provider or catalog, always the same names will be displayed and the information is not relevant. However, in a later phase extra catalogs or providers might be added.

Name of the trade item.

Copied from the External Catalog. Might be a different name than the product.

Description of the trade item.

The supplier of the trade item.

The supplier is stored in a separate entity. The Global Location Number makes the supplier unique.

Global Trade Item Number (GTIN) of the trade item.

This is the most important number of a trade item. The GTIN is copied from the external catalog.

Trade Item Number from the supplier.

External Trade Item Number from the supplier.

Code availability of the trade item.

Most used code at 2BA: 126 (means available).

Quantity of use of the trade item.

Most time this is 1 Piece. But it might be that a trade item is always used by 2 or more pieces, meters etc.

Unit of Quantity Of Use.

The unit of the price. This might be different from the order unit. This is especially the case if the price is per piece is low. In that case the price might be for 100 or 1000 pieces.

Price to Order unit factor of the trade item.

For instance if the price unit is per 100 pieces and the order unit is 1 piece. The price to order unit is 100.

Unit that is used on the Purchase Order.

The price of the trade item is only on request available.

This might apply if prices change very fast or it might be the policy of the supplier.

If the price of one trade item is low, suppliers give the price for more items, for instance for one box of 10 pieces or for 100m.

In that case the price is less inaccurate because of rounding problems.

Identification from the supplier that is the base of the reduction percentage 

The reduction percentage is stored in the Item Conditions entity.

Identification from the supplier to group trade items.

This number is necessary for reporting to statistic authorities.

In most countries only applicable  if the amount of Trade Items bought or sold abroad is above a certain amount.

Is the trade item orderable?

The minimum order quantity of the trade item.

The order quantity should always be a multiple amount of the displayed number.

This might occur if trade items are sold in a box of a certain amount, or a wire is sold by for instance 50m.

The delivery time in the unit of the Delivery Time Unit.

Most time a number of days.

Time unit that specifies the Delivery Time.

Most times in days, sometimes in weeks. 

Package type of the trade item.

For instance box or reel.

Start date from which the trade item is valid.

Date of the last change.

Deeplink to the trade item website from the supplier.

Trade Item Number of the predecessor.

GTIN of the predecessor.

Trade Item Number of the successor.

GTIN of the successor.

Provider of the Online Catalog of the trade item.

For instance a supplier name or 2BA.

Online Catalog source of the trade item.

This might be a part of the complete Online Catalog of the provider.

Name of the trade item.

Supplier of the trade item.

Supplier and Vendor should be the same. Supplier has the connection with Accounts in CE. The reason that Supplier and Vendor occur is historical. At start of the development of OPC there was only the vendor as stand alone filed without any connection. If a trade item is selected from an Online Catalog, both fields Supplier and Vendor are filled and connected with each other.

Vendor of the trade item.

Basic field for calculating the Discount and the Net Price 

Gross Price - Discount % = Net Price 

Name of the Product Catalog provider.

Name of the Online Product Catalog

There might be several Online Catalogs for the same provider. This might be a part of the complete Online Catalog of the provider.

Field value can be Yes or No

If Yes: Net Price or Discount is copied from the Item Conditions File. The Item Conditions file has his origin from the Vendor. This file contains the Discounts per Allowance Group or the Net Price for a Trade Item

Start Date of the Price of this form

This is an important field. The Net Price of the latest date before the system date is the Actual Price. If there is no Start Date found for the Net Price or for the Discount, the Gross Price of the latest date before the system date is the Actual Price.

End Date of the Price of this form

This is not a mandatory field. The End Date is most times used if there is a price that is temporary valid. After the End Date the Price with a Start Date before the displayed record is the actual price.

Gross Price, Net Price or Discount.

If this field is Gross or Net Price, the next field is Price. If this field is Discount, the next fields are Discount %1, Discount%2 and Discount%3

The Gross or Net Price

This field is displayed only if the Price Type is Gross or Net Price

The Discount %. There are 3 Discount % possible.

These fields are displayed only if the field Price Type is Discount. The Discount%3 is reserved for a project discount. This is for future use. The Discounts %1 and %2 are cumulated. For instance the Gross Price is EUR 100. Discount %1 is 10 % and %2 is 20%. The Net Price will be EUr 100 -10% is EUR 90. Eur 90 - 20 % = EUR 72.

Name of the supplier is stored in the ICC File.

Global Location Number of the supplier.

Supplier as stored in the CE entity Supplier 

MiMight be different to field supplier name. GLN is the connection between these fields.

Production date of the ICC file.

Version number of the ICC file.

This is stored in the start record ICC file.

Number of lines in the ICC file.

This is stored in the start record ICC file and can be compared with the real number of lines generated in CE.

Debtor number of the organization who is the customer of the client.

In other words: your client number at the provider of the ICC-File.

Global Location Number of the debtor from the previous field.

Your GLN number.

The description or number of the (Item) Allowance Group.

The Allowance Group is copied from the ICC File. The Item Allowance Group is the record in the entity Allowance Group in CE. They should be the same. These fields are filled only if relevant. That means not in combination with Item Number or Trade Item. The record in the Item Allowance Group is generated automatically if it doesn't exist already.

The Item Number in the ICC file. This should be same number is the Trade Item Number.

The Start Date of the Discount or the Net Price.

End date of the conditions.

Only applicable if there is a real end date for the condition. For instance sale.

Discout %1, %2 or %3.

Discounts are cumulative. For instance the gross price is EUR 100. Discount %1 is 10%. Discount %2 is 20%. The Net price will be EUR 100 - 10% = EUR 90. EUR 90 - 20% = EUR 72

The Net Price of a Trade Item. Only applicable in combination with a Item Number and Trade Item.

Enter remark here